import pymysql

db = pymysql.connect(
    host='localhost',
    port=3306,
    database='jiangsu',
    user='root',
    password='root',
    charset='utf8'
)

cursor = db.cursor()

value = ("('13', 'whh', '1990-01-20', '女'),"
         "('11', 'whh', '1990-01-20', '女'),"
         "('12', 'whh', '1990-01-20', '女')")
sql = f'insert into student (s_id, s_name, s_birth, s_sex) values {value}'
cursor.execute(sql)

db.commit()
cursor.close()
db.connect()
